Dataset Statistics
| Number of Variables |
29 |
| Number of Rows |
53572 |
| Missing Cells |
0 |
| Missing Cells (%) |
0.0% |
| Duplicate Rows |
0 |
| Duplicate Rows (%) |
0.0% |
| Total Size in Memory |
16.4 MB |
| Average Row Size in Memory |
320.4 B |
Variable Types
| Numerical |
26 |
| Categorical |
2 |
| DateTime |
1 |
sic
numerical
| Distinct Count |
377 |
| Unique (%) |
0.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
4724.0779 |
| Minimum |
100 |
| Maximum |
9995 |
| Zeros |
0 |
| Zeros (%) |
0.0% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
cik
numerical
| Distinct Count |
3602 |
| Unique (%) |
6.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
1.0747e+06 |
| Minimum |
2034 |
| Maximum |
1.8404e+06 |
| Zeros |
0 |
| Zeros (%) |
0.0% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
countryba
categorical
| Distinct Count |
46 |
| Unique (%) |
0.1% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Memory Size |
3.4 MB |
name
categorical
| Distinct Count |
3594 |
| Unique (%) |
6.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Memory Size |
4.4 MB |
| Distinct Count |
37 |
| Unique (%) |
0.1% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Memory Size |
418.7 KB |
| Minimum |
2012-03-31 00:00:00 |
| Maximum |
2021-03-31 00:00:00 |
solvency_debt_ratio
numerical
| Distinct Count |
53479 |
| Unique (%) |
99.8% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
0.6341 |
| Minimum |
0 |
| Maximum |
6.5331 |
| Zeros |
35 |
| Zeros (%) |
0.1% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
liquid_current_ratio
numerical
| Distinct Count |
53447 |
| Unique (%) |
99.8% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
2.4778 |
| Minimum |
0 |
| Maximum |
18.0877 |
| Zeros |
39 |
| Zeros (%) |
0.1% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
liquid_quick_ratio
numerical
| Distinct Count |
53427 |
| Unique (%) |
99.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
1.6119 |
| Minimum |
0 |
| Maximum |
15.2012 |
| Zeros |
98 |
| Zeros (%) |
0.2% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
liquid_cash_ratio
numerical
| Distinct Count |
53032 |
| Unique (%) |
99.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
0.992 |
| Minimum |
0 |
| Maximum |
11.719 |
| Zeros |
464 |
| Zeros (%) |
0.9% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
profit_net_margin
numerical
| Distinct Count |
53258 |
| Unique (%) |
99.4% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
-0.08217 |
| Minimum |
-1.9995 |
| Maximum |
1.9938 |
| Zeros |
36 |
| Zeros (%) |
0.1% |
| Negatives |
23592 |
| Negatives (%) |
44.0% |
profit_roa
numerical
| Distinct Count |
53503 |
| Unique (%) |
99.9% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
-0.06175 |
| Minimum |
-9.718 |
| Maximum |
12.8227 |
| Zeros |
36 |
| Zeros (%) |
0.1% |
| Negatives |
23615 |
| Negatives (%) |
44.1% |
active_acp
numerical
| Distinct Count |
53035 |
| Unique (%) |
99.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
51.4807 |
| Minimum |
0 |
| Maximum |
326.5468 |
| Zeros |
313 |
| Zeros (%) |
0.6% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
med_solvency_debt_ratio
numerical
| Distinct Count |
377 |
| Unique (%) |
0.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
0.5337 |
| Minimum |
0.03147 |
| Maximum |
3.0266 |
| Zeros |
0 |
| Zeros (%) |
0.0% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
med_liquid_current_ratio
numerical
| Distinct Count |
377 |
| Unique (%) |
0.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
2.0156 |
| Minimum |
0.1371 |
| Maximum |
9.3204 |
| Zeros |
0 |
| Zeros (%) |
0.0% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
med_liquid_quick_ratio
numerical
| Distinct Count |
377 |
| Unique (%) |
0.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
1.2108 |
| Minimum |
0.0588 |
| Maximum |
7.8005 |
| Zeros |
0 |
| Zeros (%) |
0.0% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
med_liquid_cash_ratio
numerical
| Distinct Count |
377 |
| Unique (%) |
0.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
0.5749 |
| Minimum |
0.00297 |
| Maximum |
7.4628 |
| Zeros |
0 |
| Zeros (%) |
0.0% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
med_profit_net_margin
numerical
| Distinct Count |
377 |
| Unique (%) |
0.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
-0.00062906 |
| Minimum |
-1.7985 |
| Maximum |
0.7747 |
| Zeros |
0 |
| Zeros (%) |
0.0% |
| Negatives |
21637 |
| Negatives (%) |
40.4% |
med_profit_roa
numerical
| Distinct Count |
377 |
| Unique (%) |
0.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
0.001189 |
| Minimum |
-1.4473 |
| Maximum |
1.0012 |
| Zeros |
0 |
| Zeros (%) |
0.0% |
| Negatives |
21637 |
| Negatives (%) |
40.4% |
med_active_acp
numerical
| Distinct Count |
377 |
| Unique (%) |
0.7% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
47.6383 |
| Minimum |
0 |
| Maximum |
207.6846 |
| Zeros |
3 |
| Zeros (%) |
0.0% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
y_liquid_current_ratio
numerical
| Distinct Count |
2 |
| Unique (%) |
0.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
627.8 KB |
| Mean |
0.5017 |
| Minimum |
0 |
| Maximum |
1 |
| Zeros |
26694 |
| Zeros (%) |
49.8% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
y_liquid_quick_ratio
numerical
| Distinct Count |
2 |
| Unique (%) |
0.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
627.8 KB |
| Mean |
0.5017 |
| Minimum |
0 |
| Maximum |
1 |
| Zeros |
26694 |
| Zeros (%) |
49.8% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
y_liquid_cash_ratio
numerical
| Distinct Count |
2 |
| Unique (%) |
0.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
627.8 KB |
| Mean |
0.5017 |
| Minimum |
0 |
| Maximum |
1 |
| Zeros |
26694 |
| Zeros (%) |
49.8% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
y_profit_net_margin
numerical
| Distinct Count |
2 |
| Unique (%) |
0.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
627.8 KB |
| Mean |
0.5017 |
| Minimum |
0 |
| Maximum |
1 |
| Zeros |
26693 |
| Zeros (%) |
49.8% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
y_profit_roa
numerical
| Distinct Count |
2 |
| Unique (%) |
0.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
627.8 KB |
| Mean |
0.5017 |
| Minimum |
0 |
| Maximum |
1 |
| Zeros |
26694 |
| Zeros (%) |
49.8% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
y_solvency_debt_ratio
numerical
| Distinct Count |
2 |
| Unique (%) |
0.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
627.8 KB |
| Mean |
0.4983 |
| Minimum |
0 |
| Maximum |
1 |
| Zeros |
26878 |
| Zeros (%) |
50.2% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
y_active_acp
numerical
| Distinct Count |
2 |
| Unique (%) |
0.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
627.8 KB |
| Mean |
0.4983 |
| Minimum |
0 |
| Maximum |
1 |
| Zeros |
26879 |
| Zeros (%) |
50.2% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
y_ttl
numerical
| Distinct Count |
8 |
| Unique (%) |
0.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
3.5052 |
| Minimum |
0 |
| Maximum |
7 |
| Zeros |
4162 |
| Zeros (%) |
7.8% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
y_ttl_avg
numerical
| Distinct Count |
90 |
| Unique (%) |
0.2% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
837.1 KB |
| Mean |
3.5052 |
| Minimum |
3.5 |
| Maximum |
5 |
| Zeros |
0 |
| Zeros (%) |
0.0% |
| Negatives |
0 |
| Negatives (%) |
0.0% |
| Distinct Count |
2 |
| Unique (%) |
0.0% |
| Missing |
0 |
| Missing (%) |
0.0% |
| Infinite |
0 |
| Infinite (%) |
0.0% |
| Memory Size |
627.8 KB |
| Mean |
0.5022 |
| Minimum |
0 |
| Maximum |
1 |
| Zeros |
26669 |
| Zeros (%) |
49.8% |
| Negatives |
0 |
| Negatives (%) |
0.0% |